So we're going to start out our print discussion by taking a look at three common features of printing
.
And we're going to look at orientation.
We're going to look at scaling and we're going to look at the margins.
So let's take a look and I kind of hinted at these earlier in the previous lecture but let's see them
in action here.
So first the orientation.
Right now I'm looking at my page here in Print Preview and I'm looking at it in portrait mode up and
down.
Right you got 8 1/2 by 11 sheet of paper.
I got 11 inches worth of space minus the margins given to a couple inches perhaps now but an up and
down vertical page here.
Now my document my spreadsheet is naturally it's wider than it is tall just the way of looking at it
right now.
So I believe to give me maximum space and the best real estate are used to that real estate.
I think by changing it to landscape I'm going to have a a better way of enlarging this document and
making it more presentable.
Same deal with the chart.
The chart is wider than it is tall Zola's try changing orientation.
So just a reminder.
I mean hit the back arrow here.
Take me back to my main interface of Excel to get in the print preview.
I went to file I went down to print.
It's that simple.
I'm now in print preview now on the left hand side of print preview.
I've got a couple of the more common features that people work with as they go to print to document
one of them is the orientation.
And I can see that I'm currently in portrait mode so I'm just going to change that will go from portrait
to landscape and right away.
Very nice feature here inside 2013 as well as 2010 and later releases.
Right away I get to see the effect take place and as you can see I've now created much more real estate
that I can start to consume within my document.
Scaling that thing much larger so it becomes more readable.
So there's your orientation Porcher landscape.
I like Maskaev for this document right here.
If I was working on a list something this really tall then perhaps portrait mode would be a better suit
for that type of document.
So now let's talk about scaling.
I want to bump this thing up.
Right now I got a 100 percent scaley but it's taking up roughly half the page.
So I can bump that up quite a bit.
So back into the options on the left hand side down at the bottom I got scaling and currently I can
see that it's currently no scaley.
I'll give that a click and I've got a few preset options here Fichte fit sheet on one page Fidele columns
on one page but all rows on one page.
These three options here are about scaling down.
You get a large document lots of records.
I want to get all of that to fit on a single page then great you can use those in Excel will work its
magic and then I'm on there for you or at least do its very best without getting too small and fun.
Right now all about scaling down I can't scale up using those options.
So what I am going to do is go down to custom scaling options.
This will open up the old page setup window.
This has been around for years inside of Excel and it's out of here.
I've got a lot of the repeat commands that I'm seen out in the main print interface but in here I get
scaling a just too.
Currently it's at 100 percent.
Let's try bumping that up.
I'm going to go to it's tray a 160 percent.
See how that fits.
I'm going to hit OK.
Look at that.
That looks pretty good.
I got pretty close to that right hand side.
That arrow right.
I maybe I want to get rid of that era maybe just highlight that and read that way I can get even more
space there.
But it's it's it's a choice it's a preference that we get to make as we go print the document.
What's going to best communicate.
You know looking at it again a second glance here I think is actually pretty nice having that arrow
out there.
All that white space it creates a lot of contrast and really draws attention to that specific area.
So I think maybe I'll leave it.
I could maybe bump it up maybe three four five more percent.
But I think I'm going to leave it as is so much larger taking advantage full advantage of that landscape
page that I now have.
Now I've got another issue and Saturday I got my charts and right now that chart is broken between two
pages.
I can actually see down here below I've actually got three pages.
That's why I got three pages.
I mean hit the arrow down here.
There's the rest of my chart.
All that arrow actually did go off the side of the page.
We'll see how to fix that here in a moment.
I could go back in and scale it down maybe add a percent.
Get that arrow back on its to its own page.
It's kind of a waste right there right.
But we're going to see a different way to do that.
I don't want to do it in here because I actually like the size.
But I do want to trim that arrow a little bit.
So we've got the orientation.
We've got scaley with trade the margins.
So there's a few different ways that we can work with margins.
Take a look.
I can go back down into my options here and they do have some margin options right now says normal margins
left and right is almost three quarters and mintage each so roughly an inch and a half is being taken
up by left and right margins.
And I can get into that and they do have some preset margins I can work with.
Let's see why didn't narrow.
I can go to custom.
This will open up the previous window where we saw the page tab and I changed the scaling but now I'm
on the margins tab and I can numerically adjust my margins.
Now I never found much success getting in here and changing the margins.
OK looking that didn't work.
Get back in this interface maybe monkey around a little bit more and the margins go up.
Look at it it's kind of a back and forth game adjusting numerically and taking a look back and forth
while you know what Microsoft prepared a more interactive method for us to work with the margins.
Take a look in the lower right corner of my Print Preview window.
I get two buttons.
The first one down there is my margins.
I'll give that a click.
Now I'm going to go back to the first page.
There you go.
And you can see I've got these vertical and horizontal lines here and they represent my margins.
So I'm going to grab this left hand side and I'll tug on it a little bit.
Not too much.
I don't want to get too close to the edge of the page.
Most printers have your standard desktop printers that you have sit next to your computer at your home
or in the office.
Can't really print that close to the edge of the page.
So I've created a little bit more space but you know what I'm still getting that third page in there
.
Well it's a little bit less.
Hmm.
I got to take a closer look at why I'm getting that there because I can definitely see that I'm getting
more space in there.
Oh you know what.
I got these extra little tick marks at the top of the screen.
These represent your call them with it's never the lecture about changing the width of your columns
.
These little tick marks right here represent those column withs.
So I'm going to try adjusting this one here.
Let's pull that out just a little bit.
I got some more that Arabs still get in the third page.
Look at that third page.
Still barely there.
I'm going to try point that just a little bit more.
I got more real estate and I got some more space for some more rights.
It's still got that arrow.
It must be growing with the slot with the with the cell itself with the column.
So we're going to take a look at where else we can fix that.
We'll see that here shortly.
So inside of here we got orientation we've got scaling documents much larger in that landscape mode
.
And we get some margins that we can mess around with as well.
So try this out.
Open up your monthly budget go to print preview emirate's file print.
Jump in here.
Change orientation change or scaley.
Get that document to look good.
We're going to look at a few more options here like fixing that arrow and fixing that chart.
But try these out first.